USE [SoftServeProject];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [dbo].[Users] (
[id_user] int IDENTITY(1, 1) NOT NULL,
[login] varchar(150) COLLATE Ukrainian_CI_AS NOT NULL,
[password] varchar(50) COLLATE Ukrainian_CI_AS NOT NULL,
[firstName] varchar(50) COLLATE Ukrainian_CI_AS NOT NULL,
[lastName] varchar(50) COLLATE Ukrainian_CI_AS NOT NULL,
[email] varchar(100) COLLATE Ukrainian_CI_AS NOT NULL,
[address] varchar(150) COLLATE Ukrainian_CI_AS NOT NULL,
[telephoneNumber] varchar(15) COLLATE Ukrainian_CI_AS NOT NULL,
[isAdmin] bit NULL,
CONSTRAINT [PK__Users__7C8480AE]
PRIMARY KEY NONCLUSTERED ([id_user] ASC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON )
 ON [PRIMARY],
CONSTRAINT [UQ__Users__4BAC3F29]
UNIQUE NONCLUSTERED ([login] ASC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON )
 ON [PRIMARY]
)
ON [PRIMARY];
GO




